The DataBlock Designer

The first step in creating a new DataBlock is to create the objects used by the forms and queries.  This is done within the DataBlock Designer, shown in the figure below.

The DataBlock Designer window with the Object Toolbar, Alignment Toolbar, and Design Area highlighted.

To add an object, select that object in the toolbar and then click in the design area where you want to place the object. You can then use the alignment tools to position the objects relative to each other.

Note: Drafts are temporary saves that occur automatically while working in dashboards, banded reports, and crosstab reports. Drafts do not overwrite manual saves, so it is still suggested to save your work often by selecting Save. For more information please see Drafts.


Object Toolbar

The object toolbar on the datablock designer

The following table describes the function of each icon within the Object Toolbar.  The Examples section of this document will explain the use of the most commonly used objects.

Icon Description

Selection Arrow - This tool does not create form objects, instead it is used in the typical fashion to select, move or resize objects. If you hold down the SHIFT key while using this tool, you can select multiple objects. If you click and drag, the selection tool will draw a box which can be used to select multiple objects as well.

Delete - Use this tool to delete selected object(s).

Undo / Redo - Use these tools to undo and redo actions. These tools do not create new objects, although Redo can be used to restore a deleted object.                                                                                                          

Add to Library of Objects - Adds the object(s) you currently have selected to the Library of Objects so that you can use them again later.

Insert from Library of Objects - Opens the Library of Objects so you can select from previously saved objects to add to your dashboard.

Static Label - This tool allows you to create labels on your form. Labels can contain static text or be dynamically filled using the Data Aware property. You can configure a custom cursor (such as a handpoint for a link) as well as assign events using the On-Click property.

Shape - This tool allows you to create rectangles, squares, circles and ellipses. You can choose a rounded variation of rectangles and squares.

Edit Box - This tool allows you to display a single line ofstatic text or to collect text input from a user. Edit boxes also support:

  • Populating with data (Data Aware property)
  • Collecting lists of items (Multi Entry property)
  • Setting to Read Only

Memo - This tool allows you to display or collect multi-line input from a user (scroll bars will be added as needed). Memo Fields also support:

  • Populating with data (Data Aware property)
  • Collecting lists of items (Multi Entry property)
  • Setting to Read Only

Date Edit -This tool allows you to collect date input from a user. The user can either type in a date, or click the icon to bring up a calendar. Date display format is controlled by the local PC regional settings, although the date itself is handled internally in a standard format regardless of local PC settings. Date Edit objects also support:

  • Populating with data (Data Aware property)
  • Ability to default "today" or a fixed date
  • Ability to define first day of the week

Image - This tool allows you to add images to your DataBlock. When you add an image, you have three options:

  • Image stored in the DataBlock - This option allows you to browse for an image on your hard disk and store the image statically in the DataBlock.
  • Image stored on an accessible server - This option allows you to link to an image that is stored in a location accessible to the MAP Server. This is useful as the image itself can be changed without having to update your DataBlocks (assuming the location and filename remain the same). Note that this location can be dynamic by incorporating expression logic in the pathname. Remember that the location of the image must be accessible to the MAP Server and the location is relative to MAPS, not the local PC.
  • Image retrieved from a variable - This option allows the image to be inserted from a database query (or other Argos variable). This can be very useful for dynamically displaying data-driven images. You will need to specify which variable holds the image and the MIME type of the stored image.

Image objects can be set to autosize (to match the exact size of the image) or you can turn that property off and enable stretch if you need to make the image larger or smaller.

Drop Down - Create a list of options for the user in a Drop Down object. The source of the choices can be manually entered, or dynamically generated from a SQL statement. Note that Drop Down objects only display a single field. If your query returns more than one field, Argos will prompt you for which field to display (use a Multi-column list box to display more than one column). The other SQL fields are still available for use, they just cannot be displayed. Drop Down objects also support:

  • Ability to automatically select first list item (Auto Select property)
  • Customized column headers (Columns property)
  • Ability to type in choice (Free Type property)

Check Box - Create a check box to gather Boolean (Yes/No) input from users. You can define the value of the object when it is checked and when it is unchecked, and the default state.

List Box - Display a single column of data and allow users to select one (or more) items from the list (scroll bars will be added as needed). The source of the choices can be manually entered, or dynamically generated from a SQL statement. Note that List Box objects only display a single field. If your query returns more than one field, Argos will prompt you for which field to display (use a multi-column list box to display more than one column). The other SQL fields are still available for use, they just cannot be displayed. List Box objects also support:

  • Ability to automatically select first list item (Auto Select property)
  • Customized column headers (Columns property)
  • Ability to select multiple list items (Multi Select property)
  • Ability to show the list item count (Show Item Count property)

Multi-column List Box - Works the same as the List Box except that it can display multiple columns of data. It shares the same properties as the List Box and also supports:

  • Ability to autosize a column (Auto Size Column property)
  • Ability to add column and/or row lines
  • Ability to define a custom multi-field sort order (Sort property)

Radio Buttons- allows for the creation of a panel containing of any number of radio buttons. Radio button choices can be manually entered or dynamically generated from an SQL query. The value of the selected radio button will be stored in the variable associated with the radio button panel. For example, in the column to the right, if "Button 2" is selected at runtime, "Button 2" will be stored in the variable.

  • To manually create radio buttons, select the radio button icon on the toolbar, then click within the work area to add the radio panel . Click the "Choices" property then select "Manual Entries". You will then be prompted to enter the choices to be displayed for each button. For example, in the column to the right, "Button 1, Button 2, Button 3" were entered as the choices. At runtime, the choice associated with the selected radio button will populate the variable. For example, if "Button 2" was selected at runtime, the variable for the radio button will contain "Button 2".
  • To dynamically create radio buttons, add the radio button as described above, but in this case after clicking "Choices", select "SQL statement" . The Visual Query Builder will then appear where you can create a query to return values that will be displayed as choices for radio buttons. If your SQL query returns more than one field, Argos will prompt you for which field to display. The other SQL fields are still available for use, they just are not displayed. As above, at runtime the value of the selected radio button will populate the associated variable. A maximum of 100 radio buttons can be created. If your query creates larger number, an error message will be displayed.

Button - Buttons can be used to control when other objects are run, which form is displayed, etc. The On-Click property is of special importance to button objects as it is used to define what occurs when a user clicks the button. The value of the button variable is undefined until it is clicked, at which point it takes on a value of 1. This can be a useful way to control when SQL queries run as Argos will not run a query if one of its dependent variables is undefined. By placing a line into the WHERE clause of a query like the following, you can ensure that the query will not execute until the button is clicked (replace ":button" with the name of your button object):
WHERE :button IS NOT NULL.

There are a number of events that can be activated using the On-Click Property as follows:

Activate Form – activate another form in the forms list

Clear Variables -  Clear the value of selected DataBlock variables

Fetch File – Retrieve a file from the Server

Hyperlink – Launch a URL in the default web browser

Refresh Variables -  Refresh the value of  selected DataBlock variables

Reset Variables – Reset the value of selected DataBlock variables back to their default value

Panel and Scroll Box - Creates an area on which other objects can be placed. Objects placed onto a panel or scroll box become children of their parent object. Panels and scroll boxes operate in essentially the same fashion except that scroll boxes automatically create scrollbars as needed. While neither object stores text, both allow you to define a default font. Objects placed onto the panel or scroll box will "inherit" their parents’ font settings. You can, of course, override the parent font settings by setting an objects’ font directly.

OLAP Data Cube - Create On-Line Analytical Processing (OLAP) Data Cubes.

Chart - Create a variety of charts such as bar graphs, pie charts, line charts, etc. When adding a chart, the Chart Wizard is be used to define the data source for the chart and other chart options. An advanced mode is available that gives complete control of all chart properties. However, once a chart has been modified in Advanced mode, you cannot revert back to the Chart Wizard.

The Alignment Toolbar

The Alignment Toolbar on the datablock designer.

A variety of alignment tools are available to make it easy to create attractive forms. The alignment tools are shown graphically on each button, but if you place your mouse over a button, it is described in text as well.

Alignment of a single object

When a single object is selected, the only available options are to align horizontally or vertically. Note that this alignment is with respect to the selected object’s parent. So if you align an object on a panel, it will be in relation to the panel, not the main form.

Alignment of multiple objects

The alignment tools become more useful when you select multiple objects (hold down the SHIFT key while clicking to select multiple objects). All alignment options then become available which allow you to align objects in relation to the first object selected.